Pandas Profiling Report

Dataset statistics

Number of variables	29
Number of observations	37813
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.4 MiB
Average record size in memory	232.0 B

Variable types

NUM	15
CAT	9
BOOL	5

Warnings

`city` has a high cardinality: 902 distinct values	High cardinality
`total_land_area` is highly correlated with `garden_area`	High correlation
`garden_area` is highly correlated with `total_land_area`	High correlation
`subtype_of_property` is highly correlated with `type_of_property` and 1 other fields	High correlation
`type_of_property` is highly correlated with `subtype_of_property` and 1 other fields	High correlation
`province` is highly correlated with `region` and 1 other fields	High correlation
`region` is highly correlated with `province` and 1 other fields	High correlation
`type_of_property_num` is highly correlated with `type_of_property` and 1 other fields	High correlation
`region_num` is highly correlated with `region` and 1 other fields	High correlation
`area` is highly skewed (γ1 = 21.46038373)	Skewed
`terrace_area` is highly skewed (γ1 = 113.1304659)	Skewed
`garden_area` is highly skewed (γ1 = 88.06374136)	Skewed
`total_land_area` is highly skewed (γ1 = 84.15953068)	Skewed
`id` has unique values	Unique
`nr_of_rooms` has 730 (1.9%) zeros	Zeros
`garden_area` has 20370 (53.9%) zeros	Zeros

Reproduction

Analysis started	2020-12-07 08:38:17.343852
Analysis finished	2020-12-07 08:39:41.799130
Duration	1 minute and 24.46 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

id
Real number (ℝ_≥0)

UNIQUE

Distinct	37813
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	8852120.03
Minimum	1882546
Maximum	9066628
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	1882546
5-th percentile	8271417.6
Q1	8825271
median	8954685
Q3	9020304
95-th percentile	9057871.4
Maximum	9066628
Range	7184082
Interquartile range (IQR)	195033

Descriptive statistics

Standard deviation	327088.2773
Coefficient of variation (CV)	0.03695027588
Kurtosis	50.31477971
Mean	8852120.03
Median Absolute Deviation (MAD)	79521
Skewness	-5.19368627
Sum	3.347252147e+11
Variance	1.069867411e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8939045	1	< 0.1%
8957754	1	< 0.1%
8924559	1	< 0.1%
8988046	1	< 0.1%
9057676	1	< 0.1%
9023184	1	< 0.1%
9010565	1	< 0.1%
8266535	1	< 0.1%
9063811	1	< 0.1%
8930690	1	< 0.1%
Other values (37803)	37803	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1882546	1	< 0.1%
2335739	1	< 0.1%
2784938	1	< 0.1%
3001135	1	< 0.1%
3794524	1	< 0.1%

Value	Count	Frequency (%)
9066628	1	< 0.1%
9066556	1	< 0.1%
9066527	1	< 0.1%
9066417	1	< 0.1%
9066399	1	< 0.1%

locality
Real number (ℝ_≥0)

Distinct	1014
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5138.92127
Minimum	1000
Maximum	9992
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	1000
5-th percentile	1070
Q1	2100
median	4671
Q3	8400
95-th percentile	9500
Maximum	9992
Range	8992
Interquartile range (IQR)	6300

Descriptive statistics

Standard deviation	3118.850063
Coefficient of variation (CV)	0.6069075393
Kurtosis	-1.618424221
Mean	5138.92127
Median Absolute Deviation (MAD)	3112
Skewness	0.08205409166
Sum	194318030
Variance	9727225.715
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8300	1051	2.8%
1180	728	1.9%
1000	643	1.7%
8400	581	1.5%
9000	538	1.4%
2000	474	1.3%
1050	443	1.2%
8370	415	1.1%
1070	406	1.1%
8670	343	0.9%
Other values (1004)	32191	85.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1000	643	1.7%
1020	125	0.3%
1030	324	0.9%
1040	152	0.4%
1050	443	1.2%

Value	Count	Frequency (%)
9992	3	< 0.1%
9991	69	0.2%
9990	62	0.2%
9988	9	< 0.1%
9982	4	< 0.1%

type_of_property
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

APARTMENT	20229
HOUSE	17584

Frequencies
Length

Value	Count	Frequency (%)
APARTMENT	20229	53.5%
HOUSE	17584	46.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	9
Median length	9
Mean length	7.139898977
Min length	5

subtype_of_property
Categorical

HIGH CORRELATION

Distinct	22
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

APARTMENT	15399
HOUSE	12906
VILLA	2594
DUPLEX	1306
GROUND_FLOOR	1109
Other values (17)	4499

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
APARTMENT	15399	40.7%
HOUSE	12906	34.1%
VILLA	2594	6.9%
DUPLEX	1306	3.5%
GROUND_FLOOR	1109	2.9%
PENTHOUSE	970	2.6%
FLAT_STUDIO	720	1.9%
MIXED_USE_BUILDING	446	1.2%
EXCEPTIONAL_PROPERTY	428	1.1%
SERVICE_FLAT	320	0.8%
Other values (12)	1615	4.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	20
Median length	9
Mean length	7.617671171
Min length	3

price
Real number (ℝ_≥0)

Distinct	3591
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	393353.9229
Minimum	2500
Maximum	9500000
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	2500
5-th percentile	125000
Q1	209500
median	285000
Q3	409825
95-th percentile	995000
Maximum	9500000
Range	9497500
Interquartile range (IQR)	200325

Descriptive statistics

Standard deviation	419522.594
Coefficient of variation (CV)	1.066527037
Kurtosis	53.08026823
Mean	393353.9229
Median Absolute Deviation (MAD)	90280
Skewness	5.704647086
Sum	1.487389189e+10
Variance	1.759992069e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
249000	514	1.4%
299000	481	1.3%
199000	476	1.3%
275000	461	1.2%
295000	441	1.2%
225000	408	1.1%
395000	387	1.0%
235000	381	1.0%
195000	381	1.0%
175000	380	1.0%
Other values (3581)	33503	88.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2500	3	< 0.1%
4000	1	< 0.1%
9999	1	< 0.1%
10000	3	< 0.1%
11825	1	< 0.1%

Value	Count	Frequency (%)
9500000	1	< 0.1%
8750000	1	< 0.1%
8500000	1	< 0.1%
7750000	1	< 0.1%
6500000	4	< 0.1%

nr_of_rooms
Real number (ℝ_≥0)

ZEROS

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.740221617
Minimum	0
Maximum	18
Zeros	730
Zeros (%)	1.9%
Memory size	295.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	3
95-th percentile	5
Maximum	18
Range	18
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.350243159
Coefficient of variation (CV)	0.4927496195
Kurtosis	7.135375623
Mean	2.740221617
Median Absolute Deviation (MAD)	1
Skewness	1.497759931
Sum	103616
Variance	1.823156589
Monotocity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
2	12722	33.6%
3	12108	32.0%
4	4840	12.8%
1	4248	11.2%
5	1931	5.1%
0	730	1.9%
6	714	1.9%
7	241	0.6%
8	129	0.3%
9	54	0.1%
Other values (5)	96	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	730	1.9%
1	4248	11.2%
2	12722	33.6%
3	12108	32.0%
4	4840	12.8%

Value	Count	Frequency (%)
18	5	< 0.1%
15	6	< 0.1%
12	23	0.1%
11	20	0.1%
10	42	0.1%

area
Real number (ℝ_≥0)

SKEWED

Distinct	737
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	159.1854918
Minimum	5
Maximum	11366
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	5
5-th percentile	55
Q1	90
median	125
Q3	185
95-th percentile	375
Maximum	11366
Range	11361
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	146.335724
Coefficient of variation (CV)	0.9192780218
Kurtosis	1290.644734
Mean	159.1854918
Median Absolute Deviation (MAD)	42
Skewness	21.46038373
Sum	6019281
Variance	21414.14411
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	812	2.1%
100	810	2.1%
120	715	1.9%
80	672	1.8%
110	649	1.7%
150	631	1.7%
85	613	1.6%
140	592	1.6%
70	546	1.4%
200	541	1.4%
Other values (727)	31232	82.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	1	< 0.1%
13	1	< 0.1%
14	1	< 0.1%
15	2	< 0.1%
16	7	< 0.1%

Value	Count	Frequency (%)
11366	1	< 0.1%
8750	1	< 0.1%
4380	1	< 0.1%
4000	1	< 0.1%
3500	3	< 0.1%

equiped_kitchen
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

INSTALLED	13832
UNK	11324
HYPER_EQUIPPED	5778
SEMI_EQUIPPED	2617
USA_HYPER_EQUIPPED	1921
Other values (4)	2341

Frequencies
Length

Value	Count	Frequency (%)
INSTALLED	13832	36.6%
UNK	11324	29.9%
HYPER_EQUIPPED	5778	15.3%
SEMI_EQUIPPED	2617	6.9%
USA_HYPER_EQUIPPED	1921	5.1%
NOT_INSTALLED	1436	3.8%
USA_INSTALLED	726	1.9%
USA_SEMI_EQUIPPED	159	0.4%
USA_UNINSTALLED	20	0.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	18
Median length	9
Mean length	8.966757464
Min length	3

open_fire
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

0	35747
1	2066

Common Values
Chart

Value	Count	Frequency (%)
0	35747	94.5%
1	2066	5.5%

terrace
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

1	24075
0	13738

Common Values
Chart

Value	Count	Frequency (%)
1	24075	63.7%
0	13738	36.3%

terrace_area
Real number (ℝ)

SKEWED

Distinct	208
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	11.4556105
Minimum	-1
Maximum	20000
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	-1
Q3	12
95-th percentile	50
Maximum	20000
Range	20001
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	129.897641
Coefficient of variation (CV)	11.33921592
Kurtosis	15747.18542
Mean	11.4556105
Median Absolute Deviation (MAD)	0
Skewness	113.1304659
Sum	433171
Variance	16873.39714
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-1	22341	59.1%
10	877	2.3%
20	838	2.2%
6	724	1.9%
15	678	1.8%
12	662	1.8%
8	660	1.7%
30	579	1.5%
9	540	1.4%
5	520	1.4%
Other values (198)	9394	24.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	22341	59.1%
1	67	0.2%
2	300	0.8%
3	356	0.9%
4	510	1.3%

Value	Count	Frequency (%)
20000	1	< 0.1%
8000	2	< 0.1%
6000	1	< 0.1%
3500	1	< 0.1%
3400	1	< 0.1%

garden
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

0	19037
1	18776

Common Values
Chart

Value	Count	Frequency (%)
0	19037	50.3%
1	18776	49.7%

garden_area
Real number (ℝ)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	2943
Distinct (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	683.1153043
Minimum	-1
Maximum	1134500
Zeros	20370
Zeros (%)	53.9%
Memory size	295.4 KiB

Quantile statistics

Minimum	-1
5-th percentile	0
Q1	0
median	0
Q3	280
95-th percentile	2000
Maximum	1134500
Range	1134501
Interquartile range (IQR)	280

Descriptive statistics

Standard deviation	8745.473068
Coefficient of variation (CV)	12.80233807
Kurtosis	10017.43051
Mean	683.1153043
Median Absolute Deviation (MAD)	0
Skewness	88.06374136
Sum	25830639
Variance	76483299.18
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20370	53.9%
100	242	0.6%
200	192	0.5%
50	167	0.4%
300	153	0.4%
-1	136	0.4%
400	133	0.4%
150	133	0.4%
60	130	0.3%
80	128	0.3%
Other values (2933)	16029	42.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	136	0.4%
0	20370	53.9%
1	75	0.2%
2	24	0.1%
3	26	0.1%

Value	Count	Frequency (%)
1134500	1	< 0.1%
849450	1	< 0.1%
395850	1	< 0.1%
312600	1	< 0.1%
248700	1	< 0.1%

total_land_area
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	3201
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	883.6929892
Minimum	5
Maximum	1135150
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	5
5-th percentile	60
Q1	100
median	170
Q3	482
95-th percentile	2401.2
Maximum	1135150
Range	1135145
Interquartile range (IQR)	382

Descriptive statistics

Standard deviation	8900.922236
Coefficient of variation (CV)	10.07241468
Kurtosis	9361.911167
Mean	883.6929892
Median Absolute Deviation (MAD)	92
Skewness	84.15953068
Sum	33415083
Variance	79226416.65
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	455	1.2%
100	452	1.2%
80	413	1.1%
110	379	1.0%
95	368	1.0%
120	366	1.0%
85	341	0.9%
70	323	0.9%
75	314	0.8%
105	302	0.8%
Other values (3191)	34100	90.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	1	< 0.1%
13	1	< 0.1%
14	1	< 0.1%
15	2	< 0.1%
16	7	< 0.1%

Value	Count	Frequency (%)
1135150	1	< 0.1%
850000	1	< 0.1%
396300	1	< 0.1%
312841	1	< 0.1%
250000	1	< 0.1%

nr_of_facades
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.729140772
Minimum	-1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	2
Q3	3
95-th percentile	4
Maximum	10
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.875176636
Coefficient of variation (CV)	1.084455741
Kurtosis	-1.220394999
Mean	1.729140772
Median Absolute Deviation (MAD)	1
Skewness	-0.4486850723
Sum	65384
Variance	3.516287416
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	12313	32.6%
-1	10782	28.5%
4	7966	21.1%
3	6455	17.1%
1	295	0.8%
10	1	< 0.1%
6	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	10782	28.5%
1	295	0.8%
2	12313	32.6%
3	6455	17.1%
4	7966	21.1%

Value	Count	Frequency (%)
10	1	< 0.1%
6	1	< 0.1%
4	7966	21.1%
3	6455	17.1%
2	12313	32.6%

swimming_pool
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

0	36780
1	1033

Common Values
Chart

Value	Count	Frequency (%)
0	36780	97.3%
1	1033	2.7%

building_condition
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

AS_NEW	11598
UKN	10120
GOOD	9806
TO_BE_DONE_UP	2238
TO_RENOVATE	2029
Other values (2)	2022

Frequencies
Length

Value	Count	Frequency (%)
AS_NEW	11598	30.7%
UKN	10120	26.8%
GOOD	9806	25.9%
TO_BE_DONE_UP	2238	5.9%
TO_RENOVATE	2029	5.4%
JUST_RENOVATED	1905	5.0%
TO_RESTORE	117	0.3%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	14
Median length	4
Mean length	5.776452543
Min length	3

kitchen
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

0	25033
1	12780

Common Values
Chart

Value	Count	Frequency (%)
0	25033	66.2%
1	12780	33.8%

region
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

VLA	23667
WAL	9538
BXL	4608

Frequencies
Length

Value	Count	Frequency (%)
VLA	23667	62.6%
WAL	9538	25.2%
BXL	4608	12.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

province
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

VWV	7024
VAN	5737
VOV	5043
BXL	4608
WHT	4070
Other values (6)	11331

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
VWV	7024	18.6%
VAN	5737	15.2%
VOV	5043	13.3%
BXL	4608	12.2%
WHT	4070	10.8%
VBR	3974	10.5%
VLI	1889	5.0%
WBR	1600	4.2%
WNA	1493	3.9%
WLG	1272	3.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	3
Min length	3

sq_m_price
Real number (ℝ_≥0)

Distinct	16834
Distinct (%)	44.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2666.741691
Minimum	4.17
Maximum	33000
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	4.17
5-th percentile	977.78
Q1	1753.24
median	2372.55
Q3	3105.26
95-th percentile	5186.942
Maximum	33000
Range	32995.83
Interquartile range (IQR)	1352.02

Descriptive statistics

Standard deviation	1661.788105
Coefficient of variation (CV)	0.6231530073
Kurtosis	26.85575002
Mean	2666.741691
Median Absolute Deviation (MAD)	669.41
Skewness	3.7751219
Sum	100837503.6
Variance	2761539.705
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2500	245	0.6%
3000	168	0.4%
2000	140	0.4%
1666.67	100	0.3%
1500	91	0.2%
3500	85	0.2%
1000	83	0.2%
2250	74	0.2%
2333.33	72	0.2%
2750	67	0.2%
Other values (16824)	36688	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.17	1	< 0.1%
10.92	1	< 0.1%
15.43	1	< 0.1%
30.33	1	< 0.1%
42.86	1	< 0.1%

Value	Count	Frequency (%)
33000	1	< 0.1%
31976.74	1	< 0.1%
27000	1	< 0.1%
23629.23	1	< 0.1%
21739.11	1	< 0.1%

sq_m_land_price
Real number (ℝ_≥0)

Distinct	22878
Distinct (%)	60.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1947.327265
Minimum	0.75
Maximum	33000
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	0.75
5-th percentile	182.35
Q1	655.74
median	1766.13
Q3	2663.04
95-th percentile	4561.25
Maximum	33000
Range	32999.25
Interquartile range (IQR)	2007.3

Descriptive statistics

Standard deviation	1738.105625
Coefficient of variation (CV)	0.8925595896
Kurtosis	21.1399942
Mean	1947.327265
Median Absolute Deviation (MAD)	1023.34
Skewness	3.065454916
Sum	73634285.89
Variance	3021011.163
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2500	147	0.4%
3000	95	0.3%
2000	66	0.2%
1666.67	57	0.2%
1500	55	0.1%
3500	53	0.1%
2333.33	48	0.1%
1000	43	0.1%
5000	42	0.1%
500	38	0.1%
Other values (22868)	37169	98.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.75	1	< 0.1%
1.04	1	< 0.1%
1.09	1	< 0.1%
1.41	1	< 0.1%
2.43	1	< 0.1%

Value	Count	Frequency (%)
33000	1	< 0.1%
31976.74	1	< 0.1%
27000	1	< 0.1%
23629.23	1	< 0.1%
21739.11	1	< 0.1%

city
Categorical

HIGH CARDINALITY

Distinct	902
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

KNOKKE-HEIST	1210
ANTWERPEN	1066
UCCLE	728
BRUXELLES	643
GENT	613
Other values (897)	33553

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
KNOKKE-HEIST	1210	3.2%
ANTWERPEN	1066	2.8%
UCCLE	728	1.9%
BRUXELLES	643	1.7%
GENT	613	1.6%
OOSTENDE	581	1.5%
MIDDELKERKE	504	1.3%
BRUGGE	489	1.3%
IXELLES	443	1.2%
BLANKENBERGE	415	1.1%
Other values (892)	31121	82.3%

Frequencies of value counts

Unique

Unique	80 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	26
Median length	8
Mean length	8.714542618
Min length	2

type_of_property_num
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

1	20229
2	17584

Frequencies
Length

Value	Count	Frequency (%)
1	20229	53.5%
2	17584	46.5%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

subtype_of_property_num
Real number (ℝ_≥0)

Distinct	21
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.882976754
Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	3
95-th percentile	15
Maximum	23
Range	22
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	4.285081877
Coefficient of variation (CV)	1.103555892
Kurtosis	3.705786263
Mean	3.882976754
Median Absolute Deviation (MAD)	2
Skewness	2.07697252
Sum	146827
Variance	18.36192669
Monotocity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
1	15399	40.7%
3	12906	34.1%
5	2594	6.9%
17	1555	4.1%
9	1306	3.5%
13	970	2.6%
6	720	1.9%
7	428	1.1%
10	320	0.8%
8	258	0.7%
Other values (11)	1357	3.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	15399	40.7%
2	252	0.7%
3	12906	34.1%
4	89	0.2%
5	2594	6.9%

Value	Count	Frequency (%)
23	23	0.1%
22	57	0.2%
21	73	0.2%
20	79	0.2%
19	62	0.2%

equiped_kitchen_num
Real number (ℝ)

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.273160024
Minimum	-1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	1
Q3	3
95-th percentile	5
Maximum	8
Range	9
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.972769843
Coefficient of variation (CV)	1.549506586
Kurtosis	-0.3579932249
Mean	1.273160024
Median Absolute Deviation (MAD)	2
Skewness	0.6007856698
Sum	48142
Variance	3.891820853
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
1	13832	36.6%
-1	11324	29.9%
3	5778	15.3%
5	2617	6.9%
2	1921	5.1%
4	1436	3.8%
6	726	1.9%
7	159	0.4%
8	20	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	11324	29.9%
1	13832	36.6%
2	1921	5.1%
3	5778	15.3%
4	1436	3.8%

Value	Count	Frequency (%)
8	20	0.1%
7	159	0.4%
6	726	1.9%
5	2617	6.9%
4	1436	3.8%

building_condition_num
Real number (ℝ)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.441435485
Minimum	-1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	-1
5-th percentile	-1
Q1	-1
median	1
Q3	3
95-th percentile	5
Maximum	6
Range	7
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.852571319
Coefficient of variation (CV)	1.285226664
Kurtosis	-1.001975372
Mean	1.441435485
Median Absolute Deviation (MAD)	2
Skewness	0.1214234423
Sum	54505
Variance	3.432020493
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	11598	30.7%
-1	10120	26.8%
3	9806	25.9%
4	2238	5.9%
5	2029	5.4%
2	1905	5.0%
6	117	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-1	10120	26.8%
1	11598	30.7%
2	1905	5.0%
3	9806	25.9%
4	2238	5.9%

Value	Count	Frequency (%)
6	117	0.3%
5	2029	5.4%
4	2238	5.9%
3	9806	25.9%
2	1905	5.0%

region_num
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	295.4 KiB

1	23667
2	9538
0	4608

Frequencies
Length

Value	Count	Frequency (%)
1	23667	62.6%
2	9538	25.2%
0	4608	12.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	1
Median length	1
Mean length	1
Min length	1

province_num
Real number (ℝ_≥0)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.907835929
Minimum	1
Maximum	11
Zeros	0
Zeros (%)	0.0%
Memory size	295.4 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	5
Q3	7
95-th percentile	10
Maximum	11
Range	10
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.791049227
Coefficient of variation (CV)	0.5686924475
Kurtosis	-0.7744606279
Mean	4.907835929
Median Absolute Deviation (MAD)	2
Skewness	0.3277874247
Sum	185580
Variance	7.789955787
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
6	7024	18.6%
2	5737	15.2%
5	5043	13.3%
1	4608	12.2%
8	4070	10.8%
3	3974	10.5%
4	1889	5.0%
7	1600	4.2%
11	1493	3.9%
9	1272	3.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	4608	12.2%
2	5737	15.2%
3	3974	10.5%
4	1889	5.0%
5	5043	13.3%

Value	Count	Frequency (%)
11	1493	3.9%
10	1103	2.9%
9	1272	3.4%
8	4070	10.8%
7	1600	4.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	id	locality	type_of_property	subtype_of_property	price	nr_of_rooms	area	equiped_kitchen	open_fire	terrace	terrace_area	garden	garden_area	total_land_area	nr_of_facades	building_condition	kitchen	region	province	sq_m_price	sq_m_land_price	city	type_of_property_num	subtype_of_property_num	equiped_kitchen_num	building_condition_num	region_num	province_num
0	9044081	1083	APARTMENT	APARTMENT	265000	4	90	INSTALLED	0	1	13	0	0	103	4	AS_NEW	0	BXL	BXL	2944.44	2572.82	GANSHOREN	1	1	1	1	0	1
1	9043978	1000	APARTMENT	APARTMENT	1795000	4	650	USA_HYPER_EQUIPPED	1	1	400	0	0	1050	3	AS_NEW	0	BXL	BXL	2761.54	1709.52	BRUXELLES	1	1	2	1	0	1
2	9041095	4860	HOUSE	HOUSE	320000	5	231	NOT_INSTALLED	0	1	30	1	1200	1421	3	AS_NEW	1	WAL	WLG	1385.28	225.19	PEPINSTER	2	3	4	1	2	9
3	9043036	9600	APARTMENT	APARTMENT	195000	2	75	INSTALLED	0	0	-1	0	0	75	2	GOOD	0	VLA	VOV	2600.00	2600.00	RENAIX	1	1	1	3	1	5
4	9042950	6010	APARTMENT	TRIPLEX	235000	3	149	HYPER_EQUIPPED	0	1	15	0	0	164	2	AS_NEW	0	WAL	WHT	1577.18	1432.93	COUILLET	1	4	3	1	2	8
5	9042073	1070	APARTMENT	APARTMENT	320000	3	130	USA_HYPER_EQUIPPED	0	1	14	0	0	144	2	AS_NEW	0	BXL	BXL	2461.54	2222.22	ANDERLECHT	1	1	2	1	0	1
6	9042267	7181	HOUSE	VILLA	325000	2	130	INSTALLED	0	1	30	1	600	1043	4	TO_BE_DONE_UP	0	WAL	WHT	2500.00	311.60	SENEFFE	2	5	1	4	2	8
7	9042511	5340	HOUSE	VILLA	569000	6	324	INSTALLED	0	1	57	1	1821	2202	4	JUST_RENOVATED	0	WAL	WNA	1756.17	258.40	GESVES	2	5	1	2	2	11
8	9034494	1950	APARTMENT	APARTMENT	715000	2	126	USA_HYPER_EQUIPPED	0	1	6	0	0	132	2	AS_NEW	0	VLA	VBR	5674.60	5416.67	KRAAINEM	1	1	2	1	1	3
9	9039019	1050	APARTMENT	APARTMENT	1550000	3	213	USA_HYPER_EQUIPPED	0	1	39	0	0	252	-1	AS_NEW	0	BXL	BXL	7277.00	6150.79	IXELLES	1	1	2	1	0	1

Last rows

	id	locality	type_of_property	subtype_of_property	price	nr_of_rooms	area	equiped_kitchen	terrace	terrace_area	garden	garden_area	total_land_area	nr_of_facades	building_condition	kitchen	region	province	sq_m_price	sq_m_land_price	city	type_of_property_num	subtype_of_property_num	equiped_kitchen_num	building_condition_num	region_num	province_num
37803	9038695	3000	HOUSE	HOUSE	940000	6	150	UNK	0	-1	0	0	150	-1	UKN	1	VLA	VBR	6266.67	6266.67	LEUVEN	2	3	-1	-1	1	3
37804	8704937	1840	APARTMENT	APARTMENT	310000	2	102	UNK	1	12	0	0	114	-1	UKN	1	VLA	VBR	3039.22	2719.30	LONDERZEEL	1	1	-1	-1	1	3
37805	8721413	1800	HOUSE	HOUSE	454993	3	169	UNK	0	-1	1	220	389	3	UKN	1	VLA	VBR	2692.27	1169.65	VILVOORDE	2	3	-1	-1	1	3
37806	9062950	3000	APARTMENT	FLAT_STUDIO	199900	0	26	UNK	0	-1	0	0	26	2	UKN	1	VLA	VBR	7688.46	7688.46	LEUVEN	1	6	-1	-1	1	3
37807	9023187	1570	APARTMENT	APARTMENT	215708	1	76	UNK	1	7	0	0	83	-1	UKN	1	VLA	VBR	2838.26	2598.89	GALMAARDEN	1	1	-1	-1	1	3
37808	9023190	1570	APARTMENT	APARTMENT	228208	2	83	UNK	1	7	0	0	90	-1	UKN	1	VLA	VBR	2749.49	2535.64	GALMAARDEN	1	1	-1	-1	1	3
37809	8066006	1800	APARTMENT	APARTMENT	228000	1	86	UNK	1	14	1	34	134	-1	UKN	1	VLA	VBR	2651.16	1701.49	VILVOORDE	1	1	-1	-1	1	3
37810	8966525	1500	APARTMENT	APARTMENT	306000	3	110	UNK	1	5	0	0	115	-1	UKN	1	VLA	VBR	2781.82	2660.87	HALLE	1	1	-1	-1	1	3
37811	8966523	1500	APARTMENT	APARTMENT	219000	1	65	UNK	1	22	0	0	87	-1	UKN	1	VLA	VBR	3369.23	2517.24	HALLE	1	1	-1	-1	1	3
37812	8858590	1910	APARTMENT	DUPLEX	275000	2	100	UNK	1	19	1	63	182	2	UKN	1	VLA	VBR	2750.00	1510.99	KAMPENHOUT	1	9	-1	-1	1	3

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows